﻿using System;
using System.Data;
using System.IO;
using System.Reflection;
using Graph = Microsoft.Office.Interop.Graph;
using Word = Microsoft.Office.Interop.Word;

namespace GeneralMethodClass.Office
{
    public class WordCL
    {
#region Variables
        private string strwordfilename;//文件名
        private string strwordfilepath;//文件路径
        private bool wordvisible = false;//Word文件操作是否可见
        Word._Application WordApp = new Word.Application();
        Word._Document WordDoc;
        object missing = Missing.Value;
        object oEndOfDoc = "endofdoc";
#endregion
        //Properties
#region Properties
        /**/
        /// <summary>
        /// word文件名 ,C#操作Word之2003版
        /// </summary>
        public string WordFileName
        {
            get { return strwordfilename; }
        }
        /**/
        /// <summary>
        /// word文件路径
        /// </summary>
        public string WordFilePath
        {
            get { return strwordfilepath; }
        }
#endregion
        /**/
        /// <summary>
        /// 构造word对象
        /// </summary>
        public WordCL() { }
        /**/
        /// <summary>
        /// 构造word对象 ,C#操作Word之2003版
        /// </summary>
        /// <param name="strfullfilepath">word文件全路径</param>
        public WordCL(string strfullfilepath)
        {
            WordApp.Visible = false;
            strwordfilename = Path.GetFileName(strfullfilepath);
            strwordfilepath = Path.GetDirectoryName(strfullfilepath);
            CreateWordFile(strfullfilepath);
        }
        /**/
        /// <summary>
        /// 构造word对象
        /// </summary>
        /// <param name="strfullfilepath">word文件全路径</param>
        /// <param name="overwrite">是否覆盖现有word文件</param>
        public WordCL(string strfullfilepath, bool overwrite)
        {
            strwordfilename = Path.GetFileName(strfullfilepath);
            strwordfilepath = Path.GetDirectoryName(strfullfilepath);
            WordApp.Visible = wordvisible;
            if (overwrite || !File.Exists(strfullfilepath))
            {
                CreateWordFile(strfullfilepath);
            }
            else
            {
                this.Open(strfullfilepath);
            }
        }
        /**/
        /// <summary>
        /// 打开word文件
        /// </summary>
        /// <param name="strfilepath">文件路径</param>
        public void Open(string strfilepath)
        {
            object filepath = strfilepath;
            object wrdvisible = wordvisible; WordApp.Documents.Add(ref filepath, ref missing, ref missing, ref wrdvisible);
            //C#操作Word之2003版
            WordApp.Documents.Open(ref filepath, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref wrdvisible, ref missing, ref missing, ref missing, ref missing);
            WordDoc = WordApp.Documents.Open(ref filepath, ref missing, ref wrdvisible, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref wrdvisible, ref missing, ref missing, ref missing, ref missing);
        }
        /**/
        /// <summary>
        /// 新建word文件
        /// </summary>
        /// <param name="strfullfilepath">word文件路径</param>
        private void CreateWordFile(string strfullfilepath)
        {
            object ofilename = strfullfilepath;
            WordDoc = WordApp.Documents.Add(ref missing,
             ref missing, ref missing, ref missing);
            //验证路径,C#操作Word之2003版
            if (!Directory.Exists(Path.GetDirectoryName(
            strfullfilepath))) return;
            if (Path.GetExtension(strfullfilepath).
            ToLower() != ".doc") return;
            try
            {
                if (File.Exists(strfullfilepath)) File.Delete(strfullfilepath);
                WordApp.ActiveDocument.SaveAs(ref ofilename,
                ref missing, ref missing, ref missing,
                 ref missing, ref missing,
                ref missing, ref missing, ref missing,
                 ref missing, ref missing,
                ref missing, ref missing, ref missing,
                 ref missing, ref missing);
                return;
            }
            catch
            {
                return;
            }
        }
        /**/
        /// <summary>
        /// 从模版创建word文件 ,C#操作Word之2003版 /// </summary>
        /// <param name="strdotpath">word模版路径</param>
        /// <param name="strdocpath">word文件路径</param>
        public void CreateFileFromDot(string strdotpath, string strdocpath)
        {
            object filepath = strdotpath;
            object owordfile = strdocpath;
            if (File.Exists(strdocpath))//删除已存在的文件
            {
                File.Delete(strdocpath);
            }
            WordApp.Documents.Add(ref filepath, ref missing, ref missing, ref missing);
            WordApp.ActiveDocument.SaveAs(ref owordfile,
            ref missing, ref missing, ref missing,
             ref missing, ref missing,
            ref missing, ref missing, ref missing,
             ref missing, ref missing,
            ref missing, ref missing, ref missing,
             ref missing, ref missing);
            this.Open(strdocpath);
            strwordfilepath = Path.GetDirectoryName(strdotpath);
            strwordfilename = Path.GetFileName(strdocpath);
        }
        //C#操作Word之2003版/**//// <summary>
        /// 向word结尾插入1行数据，不会换行
        /// </summary>
        /// <param name="strline">插入的字符串</param>
        public void WriteLine(string strline)
        {
            object fileName = WordFilePath + WordFileName;
            object bvisible = true;
            Word.Range wrdRng = WordDoc.Bookmarks.get_Item(ref oEndOfDoc).Range;
            wrdRng.InsertAfter(strline);
            this.Save();
        }
        /**/
        /// <summary>
        /// 将书签更新成字符串
        /// </summary>
        /// <param name="bookmarkName">书签名</param>
        /// <param name="newText">更新字符串</param>
        public void UpdateBookmark(string bookmarkName, string newText)
        {
            object name = bookmarkName;
            Word.Range rng = WordApp.ActiveDocument.Bookmarks.
            get_Item(ref name).Range;
            rng.Text = newText;
            object range = rng;
            WordApp.ActiveDocument.Bookmarks.Add(bookmarkName, ref range);
            this.Save();
        }
        /**/
        /// <summary>
        /// 将书签更新成字符串,C#操作Word之2003版
        /// </summary>
        /// <param name="bookmark">word书签</param>
        /// <param name="newText">更新字符串</param>
        public void UpdateBookmark(Word.Bookmark bookmark, string newText)
        {
            object rng = bookmark.Range;
            string bookmarkName = bookmark.Name;
            bookmark.Range.Text = newText;
            WordApp.ActiveDocument.Bookmarks.Add(bookmarkName, ref rng);
            this.Save();
        }
        /**/
        /// <summary>
        /// 更改某表的某个单元格的内容
        /// </summary>
        /// <param name="tableID">table id</param>
        /// <param name="lineID">行id</param>
        /// <param name="columnID">列id</param>
        /// <param name="context">更新字符串</param>
        public void UpdateTableContent(int tableID,
         int lineID, int columnID, string context)
        {
            Word.Table tbl = WordApp.ActiveDocument.Tables[tableID];
            tbl.Cell(lineID, columnID).Range.Text = context;
            this.Save();
        }
        /**/
        /// <summary>
        /// 插入图表 ,C#操作Word之2003版
        /// </summary>
        /// <param name="strbookmark">书签名</param>
        /// <param name="dtsheet">图表数据源datatable</param>
        /// <param name="xlcharttype">图表格式</param>
        public void InsertChart(string strbookmark,
         DataTable dtsheet, Graph.XlChartType xlcharttype)
        {
            int i, j;
            Graph.Chart wrdChart;
            Graph.Axis axis;
            object oClassType = "MSGraph.Chart.8";
            object bookmark = strbookmark;
            //在指定的书签位置插入图表
            Word.Range wrdRng = WordDoc.Bookmarks.get_Item(ref bookmark).Range;
            //初始化一张图表
            wrdChart = (Graph.Chart)wrdRng.InlineShapes.
            AddOLEObject(ref oClassType, ref missing,
            ref missing, ref missing, ref missing,
            ref missing, ref missing, ref missing).OLEFormat.Object;
            //wrdChart.Application.Visible = false;
            wrdChart.Application.PlotBy = Graph.XlRowCol.xlColumns;
            //根据Y轴来画图表

            //改变图表格式
            wrdChart.ChartType = xlcharttype;
            axis = (Graph.Axis)wrdChart.Axes(1, 1);//设置X轴的属性
            wrdChart.Application.DataSheet.Cells.Clear();
            //清空表格的初始数据
            //填充图表,起始的行号和列号都是1
            for (i = 0; i < dtsheet.Columns.Count; i++)//初始化列名
            {
                wrdChart.Application.DataSheet.Cells[1, i + 1] =
                 dtsheet.Columns[i].ColumnName;
            }
            for (i = 0; i < dtsheet.Rows.Count; i++)//填充数据
            {
                for (j = 0; j < dtsheet.Columns.Count; j++)
                {
                    wrdChart.Application.DataSheet.Cells[i + 2, j + 1] =
                     dtsheet.Rows[i][j].ToString().Replace("9999999", "100ys");
                }
            }
            //axis.MaximumScale = 1;//X轴最大刻度
            //axis.MajorUnit = 0.1;
            //C#操作Word之2003版 wrdChart.Legend.Delete();
            wrdChart.Width = 500;
            //wrdChart.Height = 666;
            //oShape.Height = oWord.InchesToPoints(3.57f);
            //更新图表并保存退出
            wrdChart.Application.Update();
            wrdChart.Application.Quit();
            this.Save();
        }
        /**/
        /// <summary>
        /// 清空文档
        /// </summary>
        public void Clear()
        {
            object Unit = (int)Word.WdUnits.wdCharacter;
            object Count = 1;
            WordApp.Selection.WholeStory();
            WordApp.Selection.Delete(ref Unit, ref Count);
            this.Save();
        }
        /**/
        /// <summary>
        /// 另存为
        /// </summary>
        /// <param name="strFileName">目标文件路径</param>
        public void SaveAs(string strFileName)
        {
            object fileName = strFileName;
            WordApp.ActiveDocument.SaveAs(ref fileName,
            ref missing, ref missing, ref missing, ref missing,
            ref missing, ref missing, ref missing, ref missing,
            ref missing, ref missing, ref missing, ref missing,
            ref missing, ref missing, ref missing);
        }
        /**/
        /// <summary>
        /// 转到指定的标签处
        /// </summary>
        /// <param name="strBookMarkName">标签名</param>
        public void GotoBookMark(string strBookMarkName)
        {
            object Bookmark = (int)Word.WdGoToItem.wdGoToBookmark;
            object NameBookMark = strBookMarkName;
            WordApp.Selection.GoTo(ref Bookmark,
             ref missing, ref missing, ref NameBookMark);
        }
        /**/
        /// <summary>
        /// 删除指定的文本
        /// </summary>
        /// <param name="text">被删除的文本</param>
        public void DeleteText(string text)
        {
            object findText = text;
            object replaceWith = "";
            object replaceAll = Word.WdReplace.wdReplaceAll;
            this.WordApp.Selection.Find.ClearFormatting();
            this.WordApp.Selection.Find.Replacement.ClearFormatting();
            this.WordApp.Selection.Find.Replacement.Text = "";
            this.WordApp.Selection.Find.Execute(ref findText,
            ref missing, ref missing, ref missing,
             ref missing, ref missing, ref missing,
            ref missing, ref missing, ref replaceWith,
             ref replaceAll, ref missing, ref missing,
            ref missing, ref missing);
            object unit = (int)Word.WdUnits.wdCharacter;
            object count = 1;
            this.WordApp.Selection.Delete(ref unit, ref count);
            this.Save();
        }
        /**/
        /// <summary>
        /// 保存当前word文档
        /// </summary>
        private void Save()
        {
            WordApp.ActiveDocument.Save();
        }
        /**/
        /// <summary>
        /// 关闭Word文件，释放对象；C#操作Word之2003版
        ///最后一定要调用此函数，否则会引起异常
        /// </summary>
        public void Close()
        {
            try
            {
                WordApp.Application.Quit(ref missing,
                 ref missing, ref missing);
                if (WordApp != null)
                {
                    WordApp = null;
                }
            }
            catch { }
            finally
            {
                GC.Collect();
                GC.WaitForPendingFinalizers();
                GC.Collect();
                GC.WaitForPendingFinalizers();
            }
        }
    }
}
